package com.xyzisme76.dao;

import com.xyzisme76.pojo.Course;
import com.xyzisme76.pojo.Sc;

import java.util.List;

public interface ScDao {
    List<Sc> getScList();

    List<Sc> getGradeBySno(String sno);
    // select * from user where name = #{name}(sql)
    List<Sc> getGradeByCno(String  cno);
    //select * from user where pwd = #{pwd}(sql)
    int insertSc (Sc sc);

    int deleteSc(int sid);

    int updateSc(Sc sc);
    double getAvg(String cno);
    List<String> getRank();
    int getGrade(Sc sc);
}
